 declare
 no emp.empno%type:=&no;
 a_sal number(7);
  b_sal number(7);
 v_sta varchar2(50):=' ';
  cursor sal_emp is
  select sal
  from emp
 where empno=no;
  begin
  open sal_emp;
  fetch sal_emp into a_sal;
  b_sal:=(a_sal-50)/100;
  dbms_output.put_line(b_sal);
 for i in 1..b_sal loop
 v_sta:=v_sta||'*';
 end loop;
 dbms_output.put_line(v_sta);
 update emp
 set stars=v_sta
 where empno=no;
 close sal_emp;
  end;
/
